Segoe UI 0 SQL Data Source=.\organice;Initial Catalog=orgAniceCRM7_StaffTimes true Integrated 73631d92-a5e9-4c30-ac19-4c35a76875bd OrgDataSource SELECT * FROM [dbo].[ufnStaffTimes_Overview] ('00000001', '2023', '1', 2) true Vorname System.String Datum System.DateTime Name System.String Anfang System.DateTime Ende System.DateTime Taetigkeit System.String Pause System.DateTime Notiz System.String Arbeitszeit System.DateTime ArbeitszeitMinuten System.Int32 MitarbeiterID System.String ID System.String TableName System.String RecordOid System.String TableName2 System.String RecordOid2 System.String OrgDataSource SELECT * FROM [dbo].[ufnStaffTimes_WorkingTimeSummary] ('00000001', '2023', '1', 2) true Vorname System.String Name System.String MitarbeiterID System.String Monat System.Int32 Jahr System.Int32 Arbeitstage System.Decimal ArbeitsfreieTageImMonat System.Decimal SOLL_Wochenstunden System.Int32 SOLL_Monatstunden System.Decimal IST_Arbeitsfrei System.Decimal IST_Monatsstunden System.Double =Fields!SOLL_Monatstunden.Value-Fields!IST_Arbeitsfrei.Value TableName System.String RecordOid System.String 27.23504mm 25mm 25mm 27.96119mm 26.17748mm 10.45382mm true true SOLL- Monatsstunden Textbox15 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt true true Krankheit, Urlaub in Std. Textbox2 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt true true Verbleiben SOLL-Stunden Textbox6 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt true true IST-Monatsstunden Textbox16 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt true true Mehr-/ Minderstunden Textbox32 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt 5.60313mm true true =Sum(Fields!SOLL_Monatstunden.Value) SOLL_Monatstunden 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Arbeitsfrei.Value) IST_Arbeitsfrei 2pt 2pt 2pt 2pt true true =Sum(Fields!SOLL_Stunden.Value) SOLL_Stunden 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) IST_Monatsstunden 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) - Sum(Fields!SOLL_Stunden.Value) SOLL_Monatstunden1 2pt 2pt 2pt 2pt 5.60312mm true true =Sum(Fields!SOLL_Monatstunden.Value) Textbox28 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Arbeitsfrei.Value) Textbox4 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!SOLL_Stunden.Value) Textbox8 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) Textbox29 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) - Sum(Fields!SOLL_Stunden.Value) Textbox34 2pt 2pt 2pt 2pt 5.60312mm true true =Sum(Fields!SOLL_Monatstunden.Value) Textbox24 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Arbeitsfrei.Value) Textbox5 2pt 2pt 2pt 2pt true true =Sum(Fields!SOLL_Stunden.Value) Textbox9 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) Textbox25 2pt 2pt 2pt 2pt true true =Sum(Fields!IST_Monatsstunden.Value) - Sum(Fields!SOLL_Stunden.Value) Textbox35 2pt 2pt 2pt 2pt 36.32112mm true true Mitarbeiter Textbox20 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt 25mm true true Monat Textbox18 LightGrey 1pt #46688b Middle 2pt 2pt 2pt 2pt =Fields!Name.Value =Fields!Name.Value =Fields!Vorname.Value 36.32112mm true true =Fields!Name.Value + ", " + Fields!Vorname.Value 2pt 2pt 2pt 2pt =Fields!Monat.Value =Fields!Monat.Value 25mm true true =Format(DateSerial(Fields!Jahr.Value, Fields!Monat.Value, 1), "MMM yyyy") 1pt 2pt 2pt 2pt 2pt true MitarbeiterName1 25mm true true 1pt 2pt 2pt 2pt 2pt Before 36.32112mm true true 2pt 2pt 2pt 2pt 25mm true true 2pt 2pt 2pt 2pt Before StaffWorkingTimeSummary 9.13565mm 0.2806mm 27.26319mm 192.69483mm Tahoma true true Monatlicher SOLL-/IST-Vergleich der Arbeitszeiten Textbox2 0mm 0.2806mm 9.26517mm 192.69483mm 1 #46688b Middle 2pt 2pt 2pt 2pt =Fields!MitarbeiterID.Value =Fields!Name.Value =Fields!Jahr.Value =Fields!Jahr.Value Descending =Fields!Monat.Value =Fields!Monat.Value =Sum(Fields!IST_Monatsstunden.Value) - Sum(Fields!SOLL_Stunden.Value) 8pt #5c5c5c False 0.5 NaN NaN NaN 8pt #5c5c5c False 0.5 NaN Opposite NaN NaN 8pt #5c5c5c Stunden 0.5 NaN NaN NaN 8pt #5c5c5c 0.5 NaN Opposite NaN NaN TopCenter Black Black Monatlicher SOLL-/IST-Vergleich der Arbeitszeiten PacificLight No Data Available StaffWorkingTimeSummary 0mm 194.03379mm 68.36189mm 185.31034mm 2 =Parameters!HideCharts.Value #e7e7ef None true 3.175mm 0.56747mm 68.36189mm 379.34413mm =Not (Parameters!TablixVisibility.Value="All" Or Parameters!TablixVisibility.Value="Summary") true true Arbeitszeiten-Details Textbox2 0.85781mm 0.0703mm 9.26517mm 193.2623mm #46688b Middle 2pt 2pt 2pt 2pt 1.85cm 1.32466cm 1.21319cm 1.26798cm 1.90152cm 3.92106cm 2.93525cm 1.0445cm true true Datum Textbox1 #46688b Middle 2pt 2pt 2pt 2pt true true Anfang Textbox341 #46688b Middle 2pt 2pt 2pt 2pt true true Ende Textbox342 #46688b Middle 2pt 2pt 2pt 2pt true true Pause Textbox356 #46688b Middle 2pt 2pt 2pt 2pt true true Arbeitszeit Textbox344 #46688b Middle 2pt 2pt 2pt 2pt true true Tätigkeit Textbox347 #46688b Middle 2pt 2pt 2pt 2pt true true Notiz Textbox348 #46688b Middle 2pt 2pt 2pt 2pt 0.56825cm true true =Fields!Datum.Value Top 2pt 2pt 2pt 2pt true true =Fields!Anfang.Value Anfang Top 2pt 2pt 2pt 2pt true true =Fields!Ende.Value Top 2pt 2pt 2pt 2pt true true =Fields!Pause.Value Top 2pt 2pt 2pt 2pt true true =Fields!Arbeitszeit.Value Top 2pt 2pt 2pt 2pt true true =Fields!Taetigkeit.Value Top 2pt 2pt 2pt 2pt true true =Fields!Notiz.Value Top 2pt 2pt 2pt 2pt 0.56825cm true true Textbox59 2pt 2pt 2pt 2pt true true Textbox363 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =INT(SUM(Fields!ArbeitszeitMinuten.Value)*60/3600) & ":" & RIGHT("0" & INT((SUM(Fields!ArbeitszeitMinuten.Value*60) MOD 3600)/60),2) Arbeitszeit1 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.56825cm true true Textbox171 2pt 2pt 2pt 2pt true true Textbox364 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =INT(SUM(Fields!ArbeitszeitMinuten.Value)*60/3600) & ":" & RIGHT("0" & INT((SUM(Fields!ArbeitszeitMinuten.Value*60) MOD 3600)/60),2) Arbeitszeit1 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.56825cm true true Textbox158 2pt 2pt 2pt 2pt true true Textbox373 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =INT(SUM(Fields!ArbeitszeitMinuten.Value)*60/3600) & ":" & RIGHT("0" & INT((SUM(Fields!ArbeitszeitMinuten.Value*60) MOD 3600)/60),2) Arbeitszeit1 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 2.72192cm true true Mitarbeiter Textbox382 #46688b Middle 2pt 2pt 2pt 2pt 2.19768cm true true Monat Textbox53 #46688b Middle 2pt 2pt 2pt 2pt After =Fields!Name.Value =Fields!Name.Value =Fields!Vorname.Value 2.72192cm true true =Fields!Name.Value + ", " + Fields!Vorname.Value 2pt 2pt 2pt 2pt =Format(Fields!Datum.Value, "yyyyMM") =Fields!Datum.Value Descending 2.19768cm true true =Format(Fields!Datum.Value, "MMM yyyy") 2pt 2pt 2pt 2pt =Fields!Datum.Value true Monatsname Before 2.19768cm true true 2pt 2pt 2pt 2pt Before 4.9196cm true true 2pt 2pt 2pt 2pt Before true StaffTimesOverview 0.94346cm 3.3175cm 19.33326cm 1 =Fields!MitarbeiterID.Value =Fields!Name.Value =Format(Fields!Datum.Value, "MMM yyyy") =Fields!Datum.Value =Sum(Fields!ArbeitszeitMinuten.Value)/60 8pt #5c5c5c False 0.5 NaN NaN NaN 8pt #5c5c5c False 0.5 NaN Opposite NaN NaN 8pt #5c5c5c Stunden 0.5 NaN NaN NaN 8pt #5c5c5c 0.5 NaN Opposite NaN NaN TopCenter Black Black Arbeitszeiten nach Mitarbeiter und Monat PacificLight No Data Available StaffTimesOverview 0.85781mm 194.39093mm 68.5904mm 184.25201mm 2 =Parameters!HideCharts.Value #e7e7ef None true 72.10133mm 0.56611mm 69.44821mm 379.34549mm 1 =Not (Parameters!TablixVisibility.Value="All" Or Parameters!TablixVisibility.Value="Overview") 142.81953mm 381.18297mm 29.7cm 21cm 2cm 2cm 2cm 2cm 0.13cm